package com.ivan.hospital.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ivan.model.entity.hosp.Department;
import org.apache.ibatis.annotations.Select;

/*
 * @Author      Ivan
 * @Date        2023/4/4 20:39
 * @Description
 */
public interface DepartmentMapper extends BaseMapper<Department> {
    //根据hoscode和depcode查询科室名称
    @Select("select * from department where hoscode = #{hoscode} and depcode = #{depcode} and is_deleted = 0")
    Department getDepartmentByHoscodeAndName(String hoscode, String depcode);
}
